| SaBillingMethodDetail_Proxy |
| EntityType | Independent |
| Logical Entity Name | SaBillingMethodDetail_Proxy |
| Default Table Name | SaBillingMethodDetail_Proxy |
| Logical Only | NO |
| Definition | |
| Note |
| SaBillingMethodDetail_Proxy Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
SaBillingMethodDetail_ProxyID |
INTEGER | NO | ||
RecordID |
INTEGER | YES | ||
| SaBillingMethodID | INTEGER | YES | ||
| OldLowRange | NUMERIC(7, 2) | YES | ||
| NewLowRange | NUMERIC(7, 2) | YES | ||
| OldHighRange | NUMERIC(7, 2) | YES | ||
| NewHighRange | NUMERIC(7, 2) | YES | ||
| OldCostPerUnit | NUMERIC(9, 2) | YES | ||
| NewCostPerUnit | NUMERIC(9, 2) | YES | ||
| OldUnitType | CHAR(1) | YES | ||
| NewUnitType | CHAR(1) | YES | ||
| OldFlatRate | NUMERIC(9, 2) | YES | ||
| NewFlatRate | NUMERIC(9, 2) | YES | ||
| OldOverUnit | NUMERIC(7, 2) | YES | ||
| NewOverUnit | NUMERIC(7, 2) | YES | ||
| OldSaBillCodeID | INTEGER | YES | ||
| NewSaBillCodeID | INTEGER | YES | ||
| OldSyCampusID | INTEGER | YES | ||
| NewSyCampusID | INTEGER | YES | ||
| OldAdCourseLevelID | INTEGER | YES | ||
| NewAdCourseLevelID | INTEGER | YES | ||
| OldIsAudit | BIT | YES | ||
| NewIsAudit | BIT | YES | ||
| OldEffectiveDateType | CHAR(1) | YES | ||
| NewEffectiveDateType | CHAR(1) | YES | ||
| OldEffectiveDate | DATETIME | YES | ||
| NewEffectiveDate | DATETIME | YES | ||
| Comment | VARCHAR(255) | YES | ||
| UserId | INTEGER | YES | ||
| ModFlag | CHAR(1) | YES | ||
| DateAdded | DATETIME | NO |
| SaBillingMethodDetail_Proxy Keys |
| Key Name | Key Type | Keys |
| SaBillingMethodDetail_Proxy_SaBillingMethodID_N_N_IDX | Inversion Entry | SaBillingMethodID |
| PK_SaBillingMethodDetail_Proxy_SaBillingMethodDetail_ProxyID | PrimaryKey | SaBillingMethodDetail_ProxyID |
| SaBillingMethodDetail_Proxy Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| BillingMethodDetail | Non-Identifying | Zero or One to Zero or More | RecordID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SaBillingMethodDetail_Proxy Check Constraints |
| Check Constraint Name | CheckConstraint |